Posted to microsoft.public.excel.worksheet.functions

Morten

external usenet poster

Posts: 15

Count no of nights between dates

I am trying to count no of nights for example stayed in a hotel,

For example
You put in the dates in row 1
Fill then row 2 with "x" if stayed at hotel

Need then another cell to calculate the number of nights that has been
stayed at the hotel (the cells filled with "x").

Can anyone help?

In advance thanks for your help

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Count if 0 and between dates	Stilmovin	Excel Worksheet Functions	14	December 17th 08 05:34 PM
Count on dates	Vijay DSK[_2_]	Excel Worksheet Functions	16	October 20th 08 04:22 PM
Count Dates	Matthew Tyrus	Excel Discussion (Misc queries)	2	October 16th 08 06:29 PM
I want to count the total Number of dates between two dates How?	seshu	Excel Worksheet Functions	3	February 7th 08 05:41 PM
need to convert list of dates to count no. of dates by week	neowok	Excel Worksheet Functions	13	January 30th 06 03:54 PM

All times are GMT +1. The time now is 03:29 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us