ExcelBanter - Counting 45 days from a certain date

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Counting 45 days from a certain date (https://www.excelbanter.com/excel-discussion-misc-queries/182535-counting-45-days-certain-date.html)

Sanjeev Raghavan[_2_]

Counting 45 days from a certain date

For eg. In have 22-Jan-08 in R4. I want to count 45 days from that day in S4
in date format.

I am not an expert in excel. That's why I need help.
Please help.
Regards,
Sanjeev.

Gary''s Student

Counting 45 days from a certain date

In S4 enter:
=R4+45
and format S4 as date
--
Gary''s Student - gsnu200777

"Sanjeev Raghavan" wrote:

For eg. In have 22-Jan-08 in R4. I want to count 45 days from that day in S4
in date format.

I am not an expert in excel. That's why I need help.
Please help.
Regards,
Sanjeev.

Sanjeev Raghavan[_2_]

Counting 45 days from a certain date

That was very simple. Thank you Gary.

"Gary''s Student" wrote:

In S4 enter:
=R4+45
and format S4 as date
--
Gary''s Student - gsnu200777

"Sanjeev Raghavan" wrote:

For eg. In have 22-Jan-08 in R4. I want to count 45 days from that day in S4
in date format.

I am not an expert in excel. That's why I need help.
Please help.
Regards,
Sanjeev.

All times are GMT +1. The time now is 09:14 AM.