Dates

[Jody]

I need to calculate a date and need help...
Enter a hire date in one cell and then I need to calculate 1st of the
following month after 30 days?
Enter a hire date in one cell and then I need to calculate 1st of the
following quarter after 1 year?
For some reason I am brain dead today - if anyone could help - it would be
greatly appreciated.

 

[David Biddulph]

You might try
=DATE(YEAR(A1+30),MONTH(A1+30)+1,1)
=DATE(YEAR(A1)+1,CEILING(MONTH(A1),3)+1,0)+1

 

[Jody]

that works perfect -
I have one more question -
If the date cell is blank - I want the cells that have formulas in them to
also have blanks so then when you put the date in the original cell it all
populates.
I am so rusty on doing this -
Thanks a million for your help...

 

[David Biddulph]

=IF(A1="","",... formula to suit ...)