Dates
 

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.

Dates
 

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

"Jody" wrote in message
...
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.

Dates
 

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" wrote:

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

"Jody" wrote in message
...
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.

Dates
 

=IF(A1="","",... formula to suit ...)
--
David Biddulph

"Jody" wrote in message
...
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" wrote:

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

"Jody" wrote in message
...
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.