Jan 05 2024 05:47 AM
I am trying to create a spreadsheet for work:
I am trying to create a formula to calculate a date depending on a figure. I have almost got it but the last logic wont work. Help me I am pulling my hair out with it.
=IF(F5<30,EDATE(G5,3),IF(F5>29,EDATE(G5,6),IF(F5>59,EDATE(G5,12))))
Any suggestions greatly welcomed.
Jan 05 2024 06:05 AM
SolutionJan 05 2024 06:20 AM
AMAZING!!! Thank you! I will be able to sleep tonight now.
Jan 05 2024 06:05 AM
Solution