Exact Date between the days in a month, across a month and between years

**Felix212** · 08-07-2019, 05:03 AM

Hi and Hello there
Need you support on how to apply formula to get exact dates.
When I try the functions, Day, Edate, i get date less one day.

**Pete_UK** · 08-07-2019, 05:07 AM

It would help if you quoted the formula you are trying to use, but why not add +1 to the end of your existing formula?

Hope this helps.

Pete

**Felix212** · 08-07-2019, 05:09 AM

When I drag the formula, I get 1 in all rows

**Pete_UK** · 08-07-2019, 05:13 AM

You might have to change your formula along the lines of:

=IF(date_cell="","",your_existing_formula +1)

Hope this helps.

Pete

**AliGW** · 08-07-2019, 05:08 AM

Ostensibly just add +1 to the formula you are using.

However, I am not clear about what you are trying to achieve. You will need to explain with examples.

**Felix212** · 08-07-2019, 05:16 AM

Please see file attached

**Pete_UK** · 08-07-2019, 05:19 AM

Put this formula in G7:

=IF(OR(E7="",F7=""),"",F7-E7+1)

then copy down.

Hope this helps.

Pete

**Felix212** · 08-07-2019, 06:03 AM

Thank you Pete.
It did work.

**avk** · 08-07-2019, 06:16 AM

Formula:

=int(f7-e7)+1

Exact Date between the days in a month, across a month and between years

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Exact Date between the days in a month, across a month and between years

Re: Exact Date between the days in a month, across a month and between years

Re: Exact Date between the days in a month, across a month and between years

Re: Exact Date between the days in a month, across a month and between years

Re: Exact Date between the days in a month, across a month and between years

Re: Exact Date between the days in a month, across a month and between years

Re: Exact Date between the days in a month, across a month and between years

Re: Exact Date between the days in a month, across a month and between years

Re: Exact Date between the days in a month, across a month and between years

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How to calculate and return exact number of days in a month based on criterias

Headcount by month when end date is blank or employee only worked a few days in a month

[SOLVED] Calculation of days per month for dates beginning in one month and ending in another month

[SOLVED] Determine work days in current month or next month based on day of the month

Date Formula for days of the month, new dates starting on the 2nd of the month.

Chart,accummulative, month by month Profit/loss over many years

convert month days and years into days

Bookmarks

Bookmarks

Posting Permissions